{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "initial_id",
   "metadata": {
    "collapsed": true,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:14:43.311740200Z",
     "start_time": "2024-08-20T07:14:42.940478600Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": "                                      商品  \\\n0       康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白质高蛋白SSS   \n1         康比特益生菌增肌粉瘦人增重增肌乳清运动锻炼健身蛋白质粉旗舰店   \n2         康比特益生菌增肌粉瘦人增重增肌乳清运动锻炼健身蛋白质粉旗舰店   \n3          康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白粉sss   \n4        【精选好物】康比特分离乳清蛋白粉低脂低碳运动健身增肌营养蛋白质   \n...                                  ...   \n1801       康比特运动营养加速电解质盐丸马拉松运动跑步户外袋装便携跑步   \n1802      【品牌福利专属】诺特兰德动植物三重蛋白粉90%高含量蛋白质    \n1803  【思思专属】诺特兰德动植物三重蛋白粉90%高含量蛋白质运动20条/桶   \n1804   【西西专属】诺特兰德女士轻盈乳清蛋白粉蛋白质膳食纤维450g/桶    \n1805              【肌酸600g】ON奥普帝蒙一水肌酸组合专用   \n\n                                                蝉妈妈商品链接  \\\n0     https://www.chanmama.com/promotionDetail/0aUUU...   \n1     https://www.chanmama.com/promotionDetail/ny43D...   \n2     https://www.chanmama.com/promotionDetail/CCqFd...   \n3     https://www.chanmama.com/promotionDetail/1zKky...   \n4     https://www.chanmama.com/promotionDetail/988c4...   \n...                                                 ...   \n1801  https://www.chanmama.com/promotionDetail/Zqvmf...   \n1802  https://www.chanmama.com/promotionDetail/3nQSy...   \n1803  https://www.chanmama.com/promotionDetail/RafaO...   \n1804  https://www.chanmama.com/promotionDetail/SUzFZ...   \n1805  https://www.chanmama.com/promotionDetail/1tdRE...   \n\n                                                 抖音商品链接  \\\n0     https://haohuo.jinritemai.com/ecommerce/trade/...   \n1     https://haohuo.jinritemai.com/ecommerce/trade/...   \n2     https://haohuo.jinritemai.com/ecommerce/trade/...   \n3     https://haohuo.jinritemai.com/ecommerce/trade/...   \n4     https://haohuo.jinritemai.com/ecommerce/trade/...   \n...                                                 ...   \n1801  https://haohuo.jinritemai.com/ecommerce/trade/...   \n1802  https://haohuo.jinritemai.com/ecommerce/trade/...   \n1803  https://haohuo.jinritemai.com/ecommerce/trade/...   \n1804  https://haohuo.jinritemai.com/ecommerce/trade/...   \n1805  https://haohuo.jinritemai.com/ecommerce/trade/...   \n\n                                                   商品图片                 产品ID  \\\n0     https://cdn-images.chanmama.com/douyin/product...  3602894078519473567   \n1     https://cdn-images.chanmama.com/douyin/product...  3442982313699464004   \n2     https://cdn-images.chanmama.com/douyin/product...  3573214322752675932   \n3     https://cdn-images.chanmama.com/douyin/product...  3497550645458818780   \n4     https://cdn-images.chanmama.com/douyin/product...  3460831451170395314   \n...                                                 ...                  ...   \n1801  https://cdn-images.chanmama.com/douyin/product...  3694391513736937864   \n1802  https://cdn-images.chanmama.com/douyin/product...  3702230267113636199   \n1803  https://cdn-images.chanmama.com/douyin/product...  3702354155428512165   \n1804  https://cdn-images.chanmama.com/douyin/product...  3629613924321735077   \n1805  https://cdn-images.chanmama.com/douyin/product...  3694956463073132896   \n\n        品牌       品类  Unnamed: 7  Unnamed: 8  Unnamed: 9  ...  Unnamed: 11  \\\n0      康比特       乳清         NaN         NaN         NaN  ...          NaN   \n1      康比特     Mass         NaN         NaN         NaN  ...          NaN   \n2      康比特     Mass         NaN         NaN         NaN  ...          NaN   \n3      康比特       乳清         NaN         NaN         NaN  ...          NaN   \n4      康比特       分离         NaN         NaN         NaN  ...          NaN   \n...    ...      ...         ...         ...         ...  ...          ...   \n1801   康比特  其他-运动补剂         NaN         NaN         NaN  ...          NaN   \n1802  诺特兰德   其他-大健康         NaN         NaN         NaN  ...          NaN   \n1803  诺特兰德   其他-大健康         NaN         NaN         NaN  ...          NaN   \n1804  诺特兰德       乳清         NaN         NaN         NaN  ...          NaN   \n1805    ON       肌酸         NaN         NaN         NaN  ...          NaN   \n\n      Unnamed: 12  Unnamed: 13    1  Unnamed: 15  Unnamed: 16  Unnamed: 17  \\\n0             NaN          NaN  2.0          NaN          NaN          NaN   \n1             NaN          NaN  3.0          NaN          NaN          NaN   \n2             NaN          NaN  4.0          NaN          NaN          NaN   \n3             NaN          NaN  5.0          NaN          NaN          NaN   \n4             NaN          NaN  6.0          NaN          NaN          NaN   \n...           ...          ...  ...          ...          ...          ...   \n1801          NaN          NaN  NaN          NaN          NaN          NaN   \n1802          NaN          NaN  NaN          NaN          NaN          NaN   \n1803          NaN          NaN  NaN          NaN          NaN          NaN   \n1804          NaN          NaN  NaN          NaN          NaN          NaN   \n1805          NaN          NaN  NaN          NaN          NaN          NaN   \n\n      Unnamed: 18  Unnamed: 19  Unnamed: 20  \n0             NaN          NaN          NaN  \n1             NaN          NaN          NaN  \n2             NaN          NaN          NaN  \n3             NaN          NaN          NaN  \n4             NaN          NaN          NaN  \n...           ...          ...          ...  \n1801          NaN          NaN          NaN  \n1802          NaN          NaN          NaN  \n1803          NaN          NaN          NaN  \n1804          NaN          NaN          NaN  \n1805          NaN          NaN          NaN  \n\n[1806 rows x 21 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>商品</th>\n      <th>蝉妈妈商品链接</th>\n      <th>抖音商品链接</th>\n      <th>商品图片</th>\n      <th>产品ID</th>\n      <th>品牌</th>\n      <th>品类</th>\n      <th>Unnamed: 7</th>\n      <th>Unnamed: 8</th>\n      <th>Unnamed: 9</th>\n      <th>...</th>\n      <th>Unnamed: 11</th>\n      <th>Unnamed: 12</th>\n      <th>Unnamed: 13</th>\n      <th>1</th>\n      <th>Unnamed: 15</th>\n      <th>Unnamed: 16</th>\n      <th>Unnamed: 17</th>\n      <th>Unnamed: 18</th>\n      <th>Unnamed: 19</th>\n      <th>Unnamed: 20</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白质高蛋白SSS</td>\n      <td>https://www.chanmama.com/promotionDetail/0aUUU...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>3602894078519473567</td>\n      <td>康比特</td>\n      <td>乳清</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>2.0</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>康比特益生菌增肌粉瘦人增重增肌乳清运动锻炼健身蛋白质粉旗舰店</td>\n      <td>https://www.chanmama.com/promotionDetail/ny43D...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>3442982313699464004</td>\n      <td>康比特</td>\n      <td>Mass</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>3.0</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>康比特益生菌增肌粉瘦人增重增肌乳清运动锻炼健身蛋白质粉旗舰店</td>\n      <td>https://www.chanmama.com/promotionDetail/CCqFd...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>3573214322752675932</td>\n      <td>康比特</td>\n      <td>Mass</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>4.0</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白粉sss</td>\n      <td>https://www.chanmama.com/promotionDetail/1zKky...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>3497550645458818780</td>\n      <td>康比特</td>\n      <td>乳清</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>5.0</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>【精选好物】康比特分离乳清蛋白粉低脂低碳运动健身增肌营养蛋白质</td>\n      <td>https://www.chanmama.com/promotionDetail/988c4...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>3460831451170395314</td>\n      <td>康比特</td>\n      <td>分离</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>6.0</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>1801</th>\n      <td>康比特运动营养加速电解质盐丸马拉松运动跑步户外袋装便携跑步</td>\n      <td>https://www.chanmama.com/promotionDetail/Zqvmf...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>3694391513736937864</td>\n      <td>康比特</td>\n      <td>其他-运动补剂</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1802</th>\n      <td>【品牌福利专属】诺特兰德动植物三重蛋白粉90%高含量蛋白质</td>\n      <td>https://www.chanmama.com/promotionDetail/3nQSy...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>3702230267113636199</td>\n      <td>诺特兰德</td>\n      <td>其他-大健康</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1803</th>\n      <td>【思思专属】诺特兰德动植物三重蛋白粉90%高含量蛋白质运动20条/桶</td>\n      <td>https://www.chanmama.com/promotionDetail/RafaO...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>3702354155428512165</td>\n      <td>诺特兰德</td>\n      <td>其他-大健康</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1804</th>\n      <td>【西西专属】诺特兰德女士轻盈乳清蛋白粉蛋白质膳食纤维450g/桶</td>\n      <td>https://www.chanmama.com/promotionDetail/SUzFZ...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>3629613924321735077</td>\n      <td>诺特兰德</td>\n      <td>乳清</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1805</th>\n      <td>【肌酸600g】ON奥普帝蒙一水肌酸组合专用</td>\n      <td>https://www.chanmama.com/promotionDetail/1tdRE...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>3694956463073132896</td>\n      <td>ON</td>\n      <td>肌酸</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>1806 rows × 21 columns</p>\n</div>"
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "data=pd.read_csv('抖音竞品动销数据 -单日 - 匹配数据.csv', encoding='utf8')\n",
    "data"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
